package com.financing.platform.dao;

import java.sql.SQLException;
import java.util.List;

import com.financing.platform.dto.AdvertDTO;
import com.financing.platform.util.SqlName;

public interface IAdvertDao extends IBaseDao  {

	/**
	 * 
	 * @Title: addAdvert
	 * @Description: 添加广告 
	 * @param @param AdvertDTO
	 * @param @return
	 * @param @throws SQLException   
	 * @return int   
	 * @throws
	 */
	public int addAdvert(AdvertDTO advertDTO) throws SQLException;
	
	/**
	 * 
	 * @Title: queryAdvertList
	 * @Description: 查询广告列表
	 * @param AdvertDTO
	 * @param @throws SQLException   
	 * @return List<AdvertDTO>   
	 * @throws
	 */
	public List<AdvertDTO> queryAdvertList(AdvertDTO advertDTO) throws SQLException;
	
	/**
	 * 
	 * @Title: queryAdvertInfo
	 * @Description: 查询活动详情 
	 * @param @param AdvertDTO
	 * @param 
	 * @param @throws SQLException   
	 * @return AdvertDTO   
	 * @throws
	 */
	public AdvertDTO queryAdvertInfo(Integer id) throws SQLException;
	
	/**
	 * 
	 * @Title: updatePublicActivities
	 * @Description: 修改活动 
	 * @param @param publicActivitiesDTO
	 * @param @return
	 * @param @throws SQLException   
	 * @return int   
	 * @throws
	 */
	public int updateAdvert(AdvertDTO advertDTO) throws SQLException;
	/**
	 * @throws SQLException 
	 * 
	 * @Title: updatePublicActivities
	 * @Description: 查询广告数 
	 * @param @param publicActivitiesDTO
	 * @param @return
	 * @param @throws SQLException   
	 * @return int   
	 * @throws
	 */
	public int queryAdvertListCount(AdvertDTO advertDTO) throws SQLException;
	
	public List<AdvertDTO> queryAdvertRecommendList(AdvertDTO advertDTO) throws SQLException;
	public int queryAdvertListRecommendCount(AdvertDTO advertDTO) throws SQLException;
}
